Database Management Systems

Goal
The goal of the course is to develop an understanding of basic concepts and principles of database management systems.

Instructor
Anthony J.T. Lee, Dept. of Information Management
Tel: (02) 2363-0231 ext. 2978
Email: jtlee@im.ntu.edu.tw

Office hour
9~10am, Friday or by appointment

Textbook
Fundamentals of Database Systems, 3rd Edition, R. Elmasri and S.B. Navathe, Addison-Wesley(開發), 1999.

References
Database Systems, 3rd Edition, P. Rob and C. Coronel, International Thomson Publishing Company, 1997.
Database Systems, second edition, T. Connolly and C. Begg, Addison-Wesley, 1999.

Topics included
Overview
Entity-relationship model
Relational data model and relational algebra
Query language and processing
SQL
Functional dependencies and normalization
Relational database design algorithms
Transaction processing concepts
Concurrency control techniques
Recovery techniques
Distributed databases and client-server architecture
Advanced data models and emerging trends

Grading
Mid-term 30%
Final 30%
Term project 15%
Homework 25%